PermanentPriceChange

Entity Definition

Logical Name : PermanentPriceChange
Physical Name : TR_CHN_PRN_PRC

A price change that modifies the inventory value for the ITEMs included in the EVENT. This price change normally only has a start date.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
EventID (FK)(PK) A unique, automatically assigned identifier for the Event ID_EV Identity integer
SaleUnitAmount The amount (either monetary or percent) to be used to change or replace the current selling price for a sale unit of the item. MO_CHN_PRN_UN_PRC MoneyShortRetail decimal(7,2)
SaleUnitAmountTypeCode A code to define how the temporary-price-change-sale-unit-amount is to be interpreted. Valid values include: PCT percent of current retail price to be added to or subtracted from the current retail to arrive at a selling price; AMT, flat monetary amount to be added to or subtracted from the current retail to arrive at a selling price; and AMTREPL, a retail sale unit price amount that is to replace the current selling price. TY_CHN_PRN_UN_PRC Code2 char(2)

Relationships

Parent Entity Verb Phrase Child Entity
PermanentPriceChange changes price for PermanentPriceChangeItemE
ItemPriceMaintenance can be a PermanentPriceChange

Logical Views containing PermanentPriceChange

Logical View
Logical 01300 - Item Price Maintenance View
Logical 06700 - Event Scheduler View